﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="AverageRatings.aspx.vb" Inherits="TheNewDesigner.QuotationAvwerage" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        &nbsp;</p>
    <p>
        A table that shows the average rating of a designer<br />
</p>
<p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="AverageRating" HeaderText="Average Rating" 
                ReadOnly="True" SortExpression="AverageRating" />
            <asp:BoundField DataField="FirstName" HeaderText="First Name" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="Last Name" 
                SortExpression="LastName" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:DesignerConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:DesignerConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT [AverageRating], [FirstName], [LastName] FROM [QuotationAverageView] ORDER BY [AverageRating] DESC">
    </asp:SqlDataSource>
</p>
</asp:Content>
